In this step,
we will continue working on the first dashboard. We will create
Scatter Chart & Line and Clustered Column charts
Visualizations
Click the Line and Clustered Column chart icon
Fields
Select the following:
A_KeyMeasures -> .Major_CrimeRate% - Under Visualizations, drag & drop it in the Column Values section.
A_KeyMeasures -> .Violent_CrimeRate% - Under Visualizations, drag & drop it in the Column Values section.
A_KeyMeasures -> .YOY_Diff_MajorCrimeRate% - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Diff_ShootingCrimeRate% - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Diff_ViolentCrimeRate% - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Major_CrimeRate% - Under Visualizations, drag & drop it in the Line Values section.
A_KeyMeasures -> .YOY_Violent_CrimeRate% - Under Visualizations, drag & drop it in the Line Values section.
Raleigh_Police_Incidents_NIBRS -> Reported_Date -> Date Hierarchy -> Month - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> Reported_Date -> Date Hierarchy -> Year - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> Reported_Date -> Date Hierarchy -> Quarter - Under Visualizations, drag & drop it in the Shared Axis section
Raleigh_Police_Incidents_NIBRS -> reported_dayofwk - Under Visualizations, drag & drop it in the Shared Axis section
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Major_CrimeRate% = Major Crime Rate
.Violent_CrimeRate% = Violent Crime Rate
.YOY_Diff_MajorCrimeRate% = YOY Diff Major Crimes
.YOY_Diff_ShootingCrimeRate% = YOY Diff Shooting Crimes
.YOY_Diff_ViolentCrimeRate% = YOY Diff Violent Crimes
.YOY_Major_CrimeRate% = YOY Major Crime Rate
.YOY_Violent_CrimeRate% = YOY Violent Crime Rate
reported_dayofwk = Reported Day of the Week
Format tab
Under Format -> General: X Position = 700 , Y Position = 144 , Width = 700 , Height = 409
Under
Format -> Legend -> Set it to ON , Position = Top Center , Color
= 000000 , Font Family = Segoe UI , Text Size = 12 pt , Style = Markers
Only
Under Format -> X Axis -> Type = Continuous , Scale Type = Linear -> Color =
000000 , Text Size = 10 pt , Font Family = Segoe UI , Title = OFF , Style
= Show Title OFF , Gridlines = OFF
Under Format -> Y Axis
-> Position = Left , Scale Type = Linear -> Start = 0.1 , Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF ,
Style
= Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 ,
Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position =
Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font
Family = Segoe UI , Title = OFF
Under Format -> Data Colors -> YOY Major Crime Rate = 51C6FF , YOY Violent Crime Rate = 6B007B , Major Crime Rate = 078AFF , Violent Crime Rate = CF6B7D
Under Format -> Data Labels -> Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 13 pt , Font Family = Segoe UI , Label Density = 50% , Show Background = Off ,
Customize Series = ON ,
(Select Major Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF) ,
(Select Violent Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF)
(Select YOY Major Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF)
(Select Major Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = OFF)
Under Format -> Shapes ->
Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style =
Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666
Filters
NoneVisualization Listing
For Line and Clustered Column chart, have the visualizations listed in the following order:
Sorting
In the Data tab -> click on Raleigh_Police_Incidents_NIBRS -> reported_dayofwk , click on Column Tools tab -> Sort by Column and select Weekday_Number
Sort by Reported Day of the week:
Step 6 - Create Violent & Major Crime Rate Year over Year (YOY) by Time of Day & Hour Line and Clustered Column chart
To get you started, copy and paste chart used in Step 5 (Violent & Major Crime Rate Year over Year (YOY) by Year, Month & Day Line and Clustered Column chart).
Click on the chart, press Ctrl+C to copy and Ctrl+V to paste it. Set the new chart as follows:
Visualizations
Click the Line and Clustered Column chart icon
Fields
Select the following:
A_KeyMeasures -> .Major_CrimeRate% - Under Visualizations, drag & drop it in the Column Values section.
A_KeyMeasures -> .Violent_CrimeRate% - Under Visualizations, drag & drop it in the Column Values section.
A_KeyMeasures -> .YOY_Diff_MajorCrimeRate% - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Diff_ShootingCrimeRate% - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Diff_ViolentCrimeRate% - Under Visualizations, drag & drop it in the Tooltips section.
A_KeyMeasures -> .YOY_Major_CrimeRate% - Under Visualizations, drag & drop it in the Line Values section.
A_KeyMeasures -> .YOY_Violent_CrimeRate% - Under Visualizations, drag & drop it in the Line Values section.
Raleigh_Police_Incidents_NIBRS -> reported_hour - Under Visualizations, drag & drop it in the Shared Axis section.Raleigh_Police_Incidents_NIBRS -> Time_By_Hour - Under Visualizations, drag & drop it in the Tooltips section.
Raleigh_Police_Incidents_NIBRS -> Time_Of_Day - Under Visualizations, drag & drop it in the Shared Axis section (Remove the extra fields).
Visualizations
Fields tab
Under Fields tab, click on the down arrow -> Rename for this visual and rename the fields as follows:
.Major_CrimeRate% = Major Crime Rate
.Violent_CrimeRate% = Violent Crime Rate
.YOY_Diff_MajorCrimeRate% = YOY Diff Major Crimes
.YOY_Diff_ShootingCrimeRate% = YOY Diff Shooting Crimes
.YOY_Diff_ViolentCrimeRate% = YOY Diff Violent Crimes
.YOY_Major_CrimeRate% = YOY Major Crime Rate
.YOY_Violent_CrimeRate% = YOY Violent Crime Rate
Time_By_hour = Time By Hour
Time_Of_Day = Time of Day
Format tab
Under Format -> General: X Position = 700 , Y Position = 533 , Width = 700 , Height = 420
Under
Format -> Legend -> Set it to ON , Position = Top Center , Color
= 000000 , Font Family = Segoe UI , Text Size = 12 pt , Style = Markers
Only
Under Format -> X Axis -> Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF
Under Format -> Y Axis
-> Position = Left , Scale Type = Linear -> Color =
000000 , Text Size = 11 pt , Font Family = Segoe UI , Title = OFF ,
Style
= Show Title OFF , Gridlines = ON , Color = 000000 , Stroke Width = 2 ,
Line Style = Dotted , Show Secondary = ON , Y-Axis (Line) Position =
Right , Scale Type = Linear , Color = 025214 , Text Size = 12 pt , Font
Family = Segoe UI , Title = OFF
Under Format -> Data Colors -> YOY Major Crime Rate = 51C6FF , YOY Violent Crime Rate = 6B007B , Major Crime Rate = 078AFF , Violent Crime Rate = CF6B7D
Under Format -> Data Labels -> Set it to ON , Color = 000000 , Value Decimal Places = 0 , Text Size = 12 pt , Font Family = Segoe UI , Label Density = 30% , Show Background = Off ,
Customize Series = ON ,
(Select Major Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON, Transparency = 30%) ,
(Select Violent Crime Rate -> Show = ON , Color = 000000 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON, Transparency = 30%)
(Select YOY Major Crime Rate -> Show = ON , Color = 026514 , Value Decimal Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density = 50% , Show Background = ON, Transparency = 30%)
(Select YOY Violent Crime Rate -> Show = ON , Color = 026514 , Value Decimal
Values = 0 , Text Size = 13 , Font Family = Segoe UI , Label Density =
50% , Show Background = ON , Transparency = 30%)
Under Format -> Shapes ->
Shade Area = ON , Stroke Width = 2 , Join Type = Round , Line Style =
Solid , Show Marker = ON , Marker Shape = . (dot) , Marker Size = 5
Under Format -> Background -> Set it to ON , Color = FFF
Under Format -> Border -> Set it to ON , Color = 666666
Filters
NoneVisualization Listing
For Line and Clustered Column chart, have the visualizations listed in the following order:
Sorting
In the Data tab -> click on Raleigh_Police_Incidents_NIBRS -> Time_By_Hour , click on Column Tools tab -> Sort by Column and select Time By HourWhen finished, save project.
For assistance in creating a Line and Clustered Column Chart in Power BI:
Tips on how to create a Line and Clustered Column Chart in Power BI